package com.example.qxfw.qxxx.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.qx.MsgOtherMinute;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
@DS("qx")
public interface MsgOtherMinuteMapper extends BaseMapper<MsgOtherMinute> {
    @Select("select station_id_c, station_name, lon, lat, ${selElement}, ${selWindD}, cnty " +
            "from msg_other_minute " +
            "where (datetime between '${startTime}' and '${endTime}')  and ${dbName}!='-65535' and ${windDElement}!='-65535' ${sql} ")
    List<MsgOtherMinute> selectList(String selElement,String selWindD,String startTime,String endTime,String dbName,String windDElement,String sql);

    @Select("select station_id_c, station_name, lon, lat, ${selElement}, cnty " +
            "from msg_other_minute " +
            "where (datetime between '${startTime}' and '${endTime}')  and ${dbName}!='-65535' ${sql} ")
    List<MsgOtherMinute> selectList1(String selElement,String startTime,String endTime,String dbName,String sql);
}
